/**
 * 
 */
package com.bifrost.sellRepository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.bifrost.sellentity.SendjfWxLog;

/**
 * @author zhuangzhuang
 * @date 2018年5月8日
 */
public interface SendjfWxLogRepository extends JpaRepository<SendjfWxLog, Integer> {
	@Query(value="SELECT * FROM(SELECT s.*,ROWNUM num FROM (SELECT * FROM sendjf_wx_log ORDER BY TBILLNO)s WHERE ROWNUM<=1000) WHERE num>=0",nativeQuery = true)
	List<SendjfWxLog> findByPage();

}
